﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsTercero" targetNamespace="http://tempuri.org/dsTercero.xsd" xmlns:mstns="http://tempuri.org/dsTercero.xsd" xmlns="http://tempuri.org/dsTercero.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (MySettings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.lbGlobalcom.My.MySettings.GlobalReference.Default.ConnectionString" Provider="Oracle.DataAccess.Client" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TER_TERCEROTableAdapter" GeneratorDataComponentClassName="TER_TERCEROTableAdapter" Name="TER_TERCERO" UserDataComponentName="TER_TERCEROTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_TERCERO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "TER_TERCERO" WHERE (("IDTERCERO" = :Original_IDTERCERO) AND ((:IsNull_NOMBRES = 1 AND "NOMBRES" IS NULL) OR ("NOMBRES" = :Original_NOMBRES)) AND ((:IsNull_APELLIDOS = 1 AND "APELLIDOS" IS NULL) OR ("APELLIDOS" = :Original_APELLIDOS)) AND ((:IsNull_DIRECCION = 1 AND "DIRECCION" IS NULL) OR ("DIRECCION" = :Original_DIRECCION)) AND ((:IsNull_DOCIDENT = 1 AND "DOCIDENT" IS NULL) OR ("DOCIDENT" = :Original_DOCIDENT)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_IDMUNICIPIO = 1 AND "IDMUNICIPIO" IS NULL) OR ("IDMUNICIPIO" = :Original_IDMUNICIPIO)) AND ((:IsNull_RAZONSOCIAL = 1 AND "RAZONSOCIAL" IS NULL) OR ("RAZONSOCIAL" = :Original_RAZONSOCIAL)) AND ((:IsNull_TELEFONO = 1 AND "TELEFONO" IS NULL) OR ("TELEFONO" = :Original_TELEFONO)) AND ((:IsNull_TIPODOCIDEN = 1 AND "TIPODOCIDEN" IS NULL) OR ("TIPODOCIDEN" = :Original_TIPODOCIDEN)) AND ((:IsNull_REGIMEN = 1 AND "REGIMEN" IS NULL) OR ("REGIMEN" = :Original_REGIMEN)) AND ((:IsNull_GRANCONTRIBUYENTE = 1 AND "GRANCONTRIBUYENTE" IS NULL) OR ("GRANCONTRIBUYENTE" = :Original_GRANCONTRIBUYENTE)) AND ((:IsNull_AUTORETENEDOR = 1 AND "AUTORETENEDOR" IS NULL) OR ("AUTORETENEDOR" = :Original_AUTORETENEDOR)) AND ((:IsNull_DV = 1 AND "DV" IS NULL) OR ("DV" = :Original_DV)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOMBRES" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="NOMBRES" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOMBRES" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="NOMBRES" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_APELLIDOS" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="APELLIDOS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_APELLIDOS" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="APELLIDOS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DIRECCION" Precision="0" ProviderType="Int32" Scale="0" Size="40" SourceColumn="DIRECCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DIRECCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="40" SourceColumn="DIRECCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DOCIDENT" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DOCIDENT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DOCIDENT" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DOCIDENT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDMUNICIPIO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDMUNICIPIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMUNICIPIO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMUNICIPIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RAZONSOCIAL" Precision="0" ProviderType="Int32" Scale="0" Size="40" SourceColumn="RAZONSOCIAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_RAZONSOCIAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="40" SourceColumn="RAZONSOCIAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TELEFONO" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="TELEFONO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TELEFONO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="TELEFONO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPODOCIDEN" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="TIPODOCIDEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TIPODOCIDEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOCIDEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_REGIMEN" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="REGIMEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_REGIMEN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="REGIMEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GRANCONTRIBUYENTE" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="GRANCONTRIBUYENTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_GRANCONTRIBUYENTE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="GRANCONTRIBUYENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AUTORETENEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="AUTORETENEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_AUTORETENEDOR" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="AUTORETENEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DV" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DV" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DV" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DV" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "TER_TERCERO" ("IDTERCERO", "NOMBRES", "APELLIDOS", "DIRECCION", "DOCIDENT", "ESTADO", "IDMUNICIPIO", "RAZONSOCIAL", "TELEFONO", "TIPODOCIDEN", "REGIMEN", "GRANCONTRIBUYENTE", "AUTORETENEDOR", "DV") VALUES (:IDTERCERO, :NOMBRES, :APELLIDOS, :DIRECCION, :DOCIDENT, :ESTADO, :IDMUNICIPIO, :RAZONSOCIAL, :TELEFONO, :TIPODOCIDEN, :REGIMEN, :GRANCONTRIBUYENTE, :AUTORETENEDOR, :DV)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOMBRES" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="NOMBRES" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="APELLIDOS" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="APELLIDOS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DIRECCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="40" SourceColumn="DIRECCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DOCIDENT" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DOCIDENT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMUNICIPIO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMUNICIPIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="RAZONSOCIAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="40" SourceColumn="RAZONSOCIAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TELEFONO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="TELEFONO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TIPODOCIDEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOCIDEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="REGIMEN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="REGIMEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="GRANCONTRIBUYENTE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="GRANCONTRIBUYENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="AUTORETENEDOR" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="AUTORETENEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DV" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DV" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IDTERCERO, NOMBRES, APELLIDOS, DIRECCION, DOCIDENT, ESTADO, IDMUNICIPIO, RAZONSOCIAL, TELEFONO, TIPODOCIDEN, REGIMEN, 
                         GRANCONTRIBUYENTE, AUTORETENEDOR, DV
FROM            TER_TERCERO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "TER_TERCERO" SET "IDTERCERO" = :IDTERCERO, "NOMBRES" = :NOMBRES, "APELLIDOS" = :APELLIDOS, "DIRECCION" = :DIRECCION, "DOCIDENT" = :DOCIDENT, "ESTADO" = :ESTADO, "IDMUNICIPIO" = :IDMUNICIPIO, "RAZONSOCIAL" = :RAZONSOCIAL, "TELEFONO" = :TELEFONO, "TIPODOCIDEN" = :TIPODOCIDEN, "REGIMEN" = :REGIMEN, "GRANCONTRIBUYENTE" = :GRANCONTRIBUYENTE, "AUTORETENEDOR" = :AUTORETENEDOR, "DV" = :DV WHERE (("IDTERCERO" = :Original_IDTERCERO) AND ((:IsNull_NOMBRES = 1 AND "NOMBRES" IS NULL) OR ("NOMBRES" = :Original_NOMBRES)) AND ((:IsNull_APELLIDOS = 1 AND "APELLIDOS" IS NULL) OR ("APELLIDOS" = :Original_APELLIDOS)) AND ((:IsNull_DIRECCION = 1 AND "DIRECCION" IS NULL) OR ("DIRECCION" = :Original_DIRECCION)) AND ((:IsNull_DOCIDENT = 1 AND "DOCIDENT" IS NULL) OR ("DOCIDENT" = :Original_DOCIDENT)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_IDMUNICIPIO = 1 AND "IDMUNICIPIO" IS NULL) OR ("IDMUNICIPIO" = :Original_IDMUNICIPIO)) AND ((:IsNull_RAZONSOCIAL = 1 AND "RAZONSOCIAL" IS NULL) OR ("RAZONSOCIAL" = :Original_RAZONSOCIAL)) AND ((:IsNull_TELEFONO = 1 AND "TELEFONO" IS NULL) OR ("TELEFONO" = :Original_TELEFONO)) AND ((:IsNull_TIPODOCIDEN = 1 AND "TIPODOCIDEN" IS NULL) OR ("TIPODOCIDEN" = :Original_TIPODOCIDEN)) AND ((:IsNull_REGIMEN = 1 AND "REGIMEN" IS NULL) OR ("REGIMEN" = :Original_REGIMEN)) AND ((:IsNull_GRANCONTRIBUYENTE = 1 AND "GRANCONTRIBUYENTE" IS NULL) OR ("GRANCONTRIBUYENTE" = :Original_GRANCONTRIBUYENTE)) AND ((:IsNull_AUTORETENEDOR = 1 AND "AUTORETENEDOR" IS NULL) OR ("AUTORETENEDOR" = :Original_AUTORETENEDOR)) AND ((:IsNull_DV = 1 AND "DV" IS NULL) OR ("DV" = :Original_DV)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOMBRES" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="NOMBRES" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="APELLIDOS" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="APELLIDOS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DIRECCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="40" SourceColumn="DIRECCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DOCIDENT" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DOCIDENT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDMUNICIPIO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMUNICIPIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="RAZONSOCIAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="40" SourceColumn="RAZONSOCIAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TELEFONO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="TELEFONO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TIPODOCIDEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOCIDEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="REGIMEN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="REGIMEN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="GRANCONTRIBUYENTE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="GRANCONTRIBUYENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="AUTORETENEDOR" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="AUTORETENEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="DV" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DV" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOMBRES" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="NOMBRES" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOMBRES" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="NOMBRES" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_APELLIDOS" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="APELLIDOS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_APELLIDOS" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="APELLIDOS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DIRECCION" Precision="0" ProviderType="Int32" Scale="0" Size="40" SourceColumn="DIRECCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DIRECCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="40" SourceColumn="DIRECCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DOCIDENT" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DOCIDENT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DOCIDENT" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DOCIDENT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDMUNICIPIO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDMUNICIPIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDMUNICIPIO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDMUNICIPIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RAZONSOCIAL" Precision="0" ProviderType="Int32" Scale="0" Size="40" SourceColumn="RAZONSOCIAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_RAZONSOCIAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="40" SourceColumn="RAZONSOCIAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TELEFONO" Precision="0" ProviderType="Int32" Scale="0" Size="20" SourceColumn="TELEFONO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TELEFONO" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="TELEFONO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TIPODOCIDEN" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="TIPODOCIDEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TIPODOCIDEN" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="TIPODOCIDEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_REGIMEN" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="REGIMEN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_REGIMEN" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="REGIMEN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GRANCONTRIBUYENTE" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="GRANCONTRIBUYENTE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_GRANCONTRIBUYENTE" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="GRANCONTRIBUYENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AUTORETENEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="AUTORETENEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_AUTORETENEDOR" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="AUTORETENEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DV" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="DV" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_DV" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="DV" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTERCERO" DataSetColumn="IDTERCERO" />
              <Mapping SourceColumn="NOMBRES" DataSetColumn="NOMBRES" />
              <Mapping SourceColumn="APELLIDOS" DataSetColumn="APELLIDOS" />
              <Mapping SourceColumn="DIRECCION" DataSetColumn="DIRECCION" />
              <Mapping SourceColumn="DOCIDENT" DataSetColumn="DOCIDENT" />
              <Mapping SourceColumn="ESTADO" DataSetColumn="ESTADO" />
              <Mapping SourceColumn="IDMUNICIPIO" DataSetColumn="IDMUNICIPIO" />
              <Mapping SourceColumn="RAZONSOCIAL" DataSetColumn="RAZONSOCIAL" />
              <Mapping SourceColumn="TELEFONO" DataSetColumn="TELEFONO" />
              <Mapping SourceColumn="TIPODOCIDEN" DataSetColumn="TIPODOCIDEN" />
              <Mapping SourceColumn="REGIMEN" DataSetColumn="REGIMEN" />
              <Mapping SourceColumn="GRANCONTRIBUYENTE" DataSetColumn="GRANCONTRIBUYENTE" />
              <Mapping SourceColumn="AUTORETENEDOR" DataSetColumn="AUTORETENEDOR" />
              <Mapping SourceColumn="DV" DataSetColumn="DV" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_TERCERO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdTercero" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdTercero" GeneratorSourceName="FillByIdTercero" GetMethodModifier="Public" GetMethodName="GetDataByIdTercero" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdTercero" UserSourceName="FillByIdTercero">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT APELLIDOS, AUTORETENEDOR, DIRECCION, DOCIDENT, DV, ESTADO, GRANCONTRIBUYENTE, IDMUNICIPIO, IDTERCERO, NOMBRES, RAZONSOCIAL, REGIMEN, TELEFONO, TIPODOCIDEN FROM TER_TERCERO WHERE (IDTERCERO = :PIDTERCERO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDTERCERO" ColumnName="IDTERCERO" DataSourceName="SAMUEL.TER_TERCERO" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDTERCERO" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDTERCERO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_TERCERO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLikeNombreApellidos" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLikeNombreApellidos" GeneratorSourceName="FillByLikeNombreApellidos" GetMethodModifier="Public" GetMethodName="GetDataByLikeNombreApellidos" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLikeNombreApellidos" UserSourceName="FillByLikeNombreApellidos">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT APELLIDOS, AUTORETENEDOR, DIRECCION, DOCIDENT, DV, ESTADO, GRANCONTRIBUYENTE, IDMUNICIPIO, IDTERCERO, NOMBRES, RAZONSOCIAL, REGIMEN, TELEFONO, TIPODOCIDEN FROM TER_TERCERO WHERE (NOMBRES + APELLIDOS LIKE :PNOMBREAPELLIDOS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PNOMBREAPELLIDOS" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName=":PNOMBREAPELLIDOS" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_TERCERO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLikeRazonS" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLikeRazonS" GeneratorSourceName="FillByLikeRazonS" GetMethodModifier="Public" GetMethodName="GetDataByLikeRazonS" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLikeRazonS" UserSourceName="FillByLikeRazonS">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT APELLIDOS, AUTORETENEDOR, DIRECCION, DOCIDENT, DV, ESTADO, GRANCONTRIBUYENTE, IDMUNICIPIO, IDTERCERO, NOMBRES, RAZONSOCIAL, REGIMEN, TELEFONO, TIPODOCIDEN FROM TER_TERCERO WHERE (RAZONSOCIAL = :PRAZONS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PRAZONS" ColumnName="RAZONSOCIAL" DataSourceName="SAMUEL.TER_TERCERO" DataTypeServer="VARCHAR2(40)" DbType="String" Direction="Input" ParameterName=":PRAZONS" Precision="0" ProviderType="Varchar2" Scale="0" Size="40" SourceColumn="RAZONSOCIAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TER_CLIENTESTableAdapter" GeneratorDataComponentClassName="TER_CLIENTESTableAdapter" Name="TER_CLIENTES" UserDataComponentName="TER_CLIENTESTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_CLIENTES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."TER_CLIENTES" WHERE (("IDCLIENTE" = :Original_IDCLIENTE) AND ((:IsNull_IDCANAL = 1 AND "IDCANAL" IS NULL) OR ("IDCANAL" = :Original_IDCANAL)) AND ((:IsNull_IDVENDEDOR = 1 AND "IDVENDEDOR" IS NULL) OR ("IDVENDEDOR" = :Original_IDVENDEDOR)) AND ((:IsNull_IDFORMAPAGO = 1 AND "IDFORMAPAGO" IS NULL) OR ("IDFORMAPAGO" = :Original_IDFORMAPAGO)) AND ((:IsNull_CUPO = 1 AND "CUPO" IS NULL) OR ("CUPO" = :Original_CUPO)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_IDLISTAGLOBAL = 1 AND "IDLISTAGLOBAL" IS NULL) OR ("IDLISTAGLOBAL" = :Original_IDLISTAGLOBAL)) AND ((:IsNull_IDTIPO = 1 AND "IDTIPO" IS NULL) OR ("IDTIPO" = :Original_IDTIPO)) AND ((:IsNull_NOMBREESTABLECIMIENTO = 1 AND "NOMBREESTABLECIMIENTO" IS NULL) OR ("NOMBREESTABLECIMIENTO" = :Original_NOMBREESTABLECIMIENTO)) AND ("SUCURSAL" = :Original_SUCURSAL) AND ((:IsNull_IDBODEGA = 1 AND "IDBODEGA" IS NULL) OR ("IDBODEGA" = :Original_IDBODEGA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCANAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDVENDEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDFORMAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CUPO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CUPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLISTAGLOBAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDLISTAGLOBAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTAGLOBAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTAGLOBAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOMBREESTABLECIMIENTO" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="NOMBREESTABLECIMIENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOMBREESTABLECIMIENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="NOMBREESTABLECIMIENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDBODEGA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."TER_CLIENTES" ("IDCLIENTE", "IDCANAL", "IDVENDEDOR", "IDFORMAPAGO", "CUPO", "ESTADO", "IDLISTAGLOBAL", "IDTIPO", "NOMBREESTABLECIMIENTO", "SUCURSAL", "IDBODEGA") VALUES (:IDCLIENTE, :IDCANAL, :IDVENDEDOR, :IDFORMAPAGO, :CUPO, :ESTADO, :IDLISTAGLOBAL, :IDTIPO, :NOMBREESTABLECIMIENTO, :SUCURSAL, :IDBODEGA)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CUPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTAGLOBAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTAGLOBAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOMBREESTABLECIMIENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="NOMBREESTABLECIMIENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDCLIENTE, IDCANAL, IDVENDEDOR, IDFORMAPAGO, CUPO, ESTADO, IDLISTAGLOBAL, IDTIPO, NOMBREESTABLECIMIENTO, SUCURSAL, IDBODEGA FROM SAMUEL.TER_CLIENTES</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."TER_CLIENTES" SET "IDCLIENTE" = :IDCLIENTE, "IDCANAL" = :IDCANAL, "IDVENDEDOR" = :IDVENDEDOR, "IDFORMAPAGO" = :IDFORMAPAGO, "CUPO" = :CUPO, "ESTADO" = :ESTADO, "IDLISTAGLOBAL" = :IDLISTAGLOBAL, "IDTIPO" = :IDTIPO, "NOMBREESTABLECIMIENTO" = :NOMBREESTABLECIMIENTO, "SUCURSAL" = :SUCURSAL, "IDBODEGA" = :IDBODEGA WHERE (("IDCLIENTE" = :Original_IDCLIENTE) AND ((:IsNull_IDCANAL = 1 AND "IDCANAL" IS NULL) OR ("IDCANAL" = :Original_IDCANAL)) AND ((:IsNull_IDVENDEDOR = 1 AND "IDVENDEDOR" IS NULL) OR ("IDVENDEDOR" = :Original_IDVENDEDOR)) AND ((:IsNull_IDFORMAPAGO = 1 AND "IDFORMAPAGO" IS NULL) OR ("IDFORMAPAGO" = :Original_IDFORMAPAGO)) AND ((:IsNull_CUPO = 1 AND "CUPO" IS NULL) OR ("CUPO" = :Original_CUPO)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_IDLISTAGLOBAL = 1 AND "IDLISTAGLOBAL" IS NULL) OR ("IDLISTAGLOBAL" = :Original_IDLISTAGLOBAL)) AND ((:IsNull_IDTIPO = 1 AND "IDTIPO" IS NULL) OR ("IDTIPO" = :Original_IDTIPO)) AND ((:IsNull_NOMBREESTABLECIMIENTO = 1 AND "NOMBREESTABLECIMIENTO" IS NULL) OR ("NOMBREESTABLECIMIENTO" = :Original_NOMBREESTABLECIMIENTO)) AND ("SUCURSAL" = :Original_SUCURSAL) AND ((:IsNull_IDBODEGA = 1 AND "IDBODEGA" IS NULL) OR ("IDBODEGA" = :Original_IDBODEGA)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CUPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDLISTAGLOBAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTAGLOBAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOMBREESTABLECIMIENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="NOMBREESTABLECIMIENTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDCANAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDCANAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDCANAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDVENDEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDFORMAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CUPO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CUPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDLISTAGLOBAL" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDLISTAGLOBAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDLISTAGLOBAL" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDLISTAGLOBAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOMBREESTABLECIMIENTO" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="NOMBREESTABLECIMIENTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOMBREESTABLECIMIENTO" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="NOMBREESTABLECIMIENTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_SUCURSAL" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDBODEGA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDBODEGA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDBODEGA" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCLIENTE" DataSetColumn="IDCLIENTE" />
              <Mapping SourceColumn="IDCANAL" DataSetColumn="IDCANAL" />
              <Mapping SourceColumn="IDVENDEDOR" DataSetColumn="IDVENDEDOR" />
              <Mapping SourceColumn="IDFORMAPAGO" DataSetColumn="IDFORMAPAGO" />
              <Mapping SourceColumn="CUPO" DataSetColumn="CUPO" />
              <Mapping SourceColumn="ESTADO" DataSetColumn="ESTADO" />
              <Mapping SourceColumn="IDLISTAGLOBAL" DataSetColumn="IDLISTAGLOBAL" />
              <Mapping SourceColumn="IDTIPO" DataSetColumn="IDTIPO" />
              <Mapping SourceColumn="NOMBREESTABLECIMIENTO" DataSetColumn="NOMBREESTABLECIMIENTO" />
              <Mapping SourceColumn="SUCURSAL" DataSetColumn="SUCURSAL" />
              <Mapping SourceColumn="IDBODEGA" DataSetColumn="IDBODEGA" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_CLIENTES" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="CLI_CANAL" Modifier="Public" Name="CLI_CANAL" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="CLI_CANAL">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDCANAL
FROM         TER_CLIENTES
WHERE     (IDCLIENTE = :PCLIENTE) AND (SUCURSAL = :PSUCURSAL)
GROUP BY IDCANAL</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PCLIENTE" ColumnName="IDCLIENTE" DataSourceName="SAMUEL.TER_CLIENTES" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PSUCURSAL" ColumnName="SUCURSAL" DataSourceName="SAMUEL.TER_CLIENTES" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PSUCURSAL" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_CLIENTES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdCliente" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdCliente" GeneratorSourceName="FillByIdCliente" GetMethodModifier="Public" GetMethodName="GetDataByIdCliente" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdCliente" UserSourceName="FillByIdCliente">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDCLIENTE, IDCANAL, IDVENDEDOR, IDFORMAPAGO, CUPO, ESTADO, IDLISTAGLOBAL, IDTIPO, NOMBREESTABLECIMIENTO, SUCURSAL, 
                      IDBODEGA
FROM         TER_CLIENTES
WHERE     (IDCLIENTE = :PIDCLIENTE)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDCLIENTE" ColumnName="IDCLIENTE" DataSourceName="SAMUEL.TER_CLIENTES" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_CLIENTES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdClienteSucursal" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdClienteSucursal" GeneratorSourceName="FillByIdClienteSucursal" GetMethodModifier="Public" GetMethodName="GetDataByIdClienteSucursal" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdClienteSucursal" UserSourceName="FillByIdClienteSucursal">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDCLIENTE, IDCANAL, IDVENDEDOR, IDFORMAPAGO, CUPO, ESTADO, IDLISTAGLOBAL, IDTIPO, NOMBREESTABLECIMIENTO, SUCURSAL, 
                      IDBODEGA
FROM         TER_CLIENTES
WHERE     (IDCLIENTE = :PIDCLIENTE) AND (SUCURSAL = :PSUCURSAL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDCLIENTE" ColumnName="IDCLIENTE" DataSourceName="SAMUEL.TER_CLIENTES" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDCLIENTE" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDCLIENTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PSUCURSAL" ColumnName="SUCURSAL" DataSourceName="SAMUEL.TER_CLIENTES" DataTypeServer="NUMBER(22)" DbType="Decimal" Direction="Input" ParameterName=":PSUCURSAL" Precision="38" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="SUCURSAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TER_PROVEEDORESTableAdapter" GeneratorDataComponentClassName="TER_PROVEEDORESTableAdapter" Name="TER_PROVEEDORES" UserDataComponentName="TER_PROVEEDORESTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_PROVEEDORES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."TER_PROVEEDORES" WHERE (("IDPROVEEDOR" = :Original_IDPROVEEDOR) AND ((:IsNull_IDFORMAPAGO = 1 AND "IDFORMAPAGO" IS NULL) OR ("IDFORMAPAGO" = :Original_IDFORMAPAGO)) AND ((:IsNull_CUPO = 1 AND "CUPO" IS NULL) OR ("CUPO" = :Original_CUPO)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_EMAIL = 1 AND "EMAIL" IS NULL) OR ("EMAIL" = :Original_EMAIL)) AND ((:IsNull_PAGWEB = 1 AND "PAGWEB" IS NULL) OR ("PAGWEB" = :Original_PAGWEB)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDFORMAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CUPO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CUPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EMAIL" Precision="0" ProviderType="Int32" Scale="0" Size="50" SourceColumn="EMAIL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EMAIL" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="EMAIL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PAGWEB" Precision="0" ProviderType="Int32" Scale="0" Size="70" SourceColumn="PAGWEB" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PAGWEB" Precision="0" ProviderType="Varchar2" Scale="0" Size="70" SourceColumn="PAGWEB" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."TER_PROVEEDORES" ("IDPROVEEDOR", "IDFORMAPAGO", "CUPO", "ESTADO", "EMAIL", "PAGWEB") VALUES (:IDPROVEEDOR, :IDFORMAPAGO, :CUPO, :ESTADO, :EMAIL, :PAGWEB)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CUPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EMAIL" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="EMAIL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PAGWEB" Precision="0" ProviderType="Varchar2" Scale="0" Size="70" SourceColumn="PAGWEB" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDPROVEEDOR, IDFORMAPAGO, CUPO, ESTADO, EMAIL, PAGWEB FROM SAMUEL.TER_PROVEEDORES</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."TER_PROVEEDORES" SET "IDPROVEEDOR" = :IDPROVEEDOR, "IDFORMAPAGO" = :IDFORMAPAGO, "CUPO" = :CUPO, "ESTADO" = :ESTADO, "EMAIL" = :EMAIL, "PAGWEB" = :PAGWEB WHERE (("IDPROVEEDOR" = :Original_IDPROVEEDOR) AND ((:IsNull_IDFORMAPAGO = 1 AND "IDFORMAPAGO" IS NULL) OR ("IDFORMAPAGO" = :Original_IDFORMAPAGO)) AND ((:IsNull_CUPO = 1 AND "CUPO" IS NULL) OR ("CUPO" = :Original_CUPO)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_EMAIL = 1 AND "EMAIL" IS NULL) OR ("EMAIL" = :Original_EMAIL)) AND ((:IsNull_PAGWEB = 1 AND "PAGWEB" IS NULL) OR ("PAGWEB" = :Original_PAGWEB)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="CUPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EMAIL" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="EMAIL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PAGWEB" Precision="0" ProviderType="Varchar2" Scale="0" Size="70" SourceColumn="PAGWEB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDFORMAPAGO" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDFORMAPAGO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDFORMAPAGO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CUPO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_CUPO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="CUPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EMAIL" Precision="0" ProviderType="Int32" Scale="0" Size="50" SourceColumn="EMAIL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EMAIL" Precision="0" ProviderType="Varchar2" Scale="0" Size="50" SourceColumn="EMAIL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PAGWEB" Precision="0" ProviderType="Int32" Scale="0" Size="70" SourceColumn="PAGWEB" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PAGWEB" Precision="0" ProviderType="Varchar2" Scale="0" Size="70" SourceColumn="PAGWEB" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPROVEEDOR" DataSetColumn="IDPROVEEDOR" />
              <Mapping SourceColumn="IDFORMAPAGO" DataSetColumn="IDFORMAPAGO" />
              <Mapping SourceColumn="CUPO" DataSetColumn="CUPO" />
              <Mapping SourceColumn="ESTADO" DataSetColumn="ESTADO" />
              <Mapping SourceColumn="EMAIL" DataSetColumn="EMAIL" />
              <Mapping SourceColumn="PAGWEB" DataSetColumn="PAGWEB" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_PROVEEDORES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdProveedor" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdProveedor" GeneratorSourceName="FillByIdProveedor" GetMethodModifier="Public" GetMethodName="GetDataByIdProveedor" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdProveedor" UserSourceName="FillByIdProveedor">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDPROVEEDOR, IDFORMAPAGO, CUPO, ESTADO, EMAIL, PAGWEB
FROM         TER_PROVEEDORES
WHERE     (IDPROVEEDOR = :PIDPROVEEDOR)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDPROVEEDOR" ColumnName="IDPROVEEDOR" DataSourceName="SAMUEL.TER_PROVEEDORES" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDPROVEEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDPROVEEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TER_VENDEDORTableAdapter" GeneratorDataComponentClassName="TER_VENDEDORTableAdapter" Name="TER_VENDEDOR" UserDataComponentName="TER_VENDEDORTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_VENDEDOR" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."TER_VENDEDOR" WHERE (("IDVENDEDOR" = :Original_IDVENDEDOR) AND ((:IsNull_IDTIPOVENDEDOR = 1 AND "IDTIPOVENDEDOR" IS NULL) OR ("IDTIPOVENDEDOR" = :Original_IDTIPOVENDEDOR)) AND ((:IsNull_IDZONA = 1 AND "IDZONA" IS NULL) OR ("IDZONA" = :Original_IDZONA)) AND ((:IsNull_ACUMULACOMISION = 1 AND "ACUMULACOMISION" IS NULL) OR ("ACUMULACOMISION" = :Original_ACUMULACOMISION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOVENDEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDZONA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDZONA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDZONA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDZONA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ACUMULACOMISION" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ACUMULACOMISION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ACUMULACOMISION" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACUMULACOMISION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."TER_VENDEDOR" ("IDVENDEDOR", "IDTIPOVENDEDOR", "IDZONA", "ACUMULACOMISION") VALUES (:IDVENDEDOR, :IDTIPOVENDEDOR, :IDZONA, :ACUMULACOMISION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDZONA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDZONA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ACUMULACOMISION" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACUMULACOMISION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDVENDEDOR, IDTIPOVENDEDOR, IDZONA, ACUMULACOMISION FROM SAMUEL.TER_VENDEDOR</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."TER_VENDEDOR" SET "IDVENDEDOR" = :IDVENDEDOR, "IDTIPOVENDEDOR" = :IDTIPOVENDEDOR, "IDZONA" = :IDZONA, "ACUMULACOMISION" = :ACUMULACOMISION WHERE (("IDVENDEDOR" = :Original_IDVENDEDOR) AND ((:IsNull_IDTIPOVENDEDOR = 1 AND "IDTIPOVENDEDOR" IS NULL) OR ("IDTIPOVENDEDOR" = :Original_IDTIPOVENDEDOR)) AND ((:IsNull_IDZONA = 1 AND "IDZONA" IS NULL) OR ("IDZONA" = :Original_IDZONA)) AND ((:IsNull_ACUMULACOMISION = 1 AND "ACUMULACOMISION" IS NULL) OR ("ACUMULACOMISION" = :Original_ACUMULACOMISION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDZONA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDZONA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="ACUMULACOMISION" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACUMULACOMISION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDTIPOVENDEDOR" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDZONA" Precision="0" ProviderType="Int32" Scale="0" Size="5" SourceColumn="IDZONA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDZONA" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDZONA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ACUMULACOMISION" Precision="0" ProviderType="Int32" Scale="0" Size="1" SourceColumn="ACUMULACOMISION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="Original_ACUMULACOMISION" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumn="ACUMULACOMISION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDVENDEDOR" DataSetColumn="IDVENDEDOR" />
              <Mapping SourceColumn="IDTIPOVENDEDOR" DataSetColumn="IDTIPOVENDEDOR" />
              <Mapping SourceColumn="IDZONA" DataSetColumn="IDZONA" />
              <Mapping SourceColumn="ACUMULACOMISION" DataSetColumn="ACUMULACOMISION" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_VENDEDOR" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdVendedor" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdVendedor" GeneratorSourceName="FillByIdVendedor" GetMethodModifier="Public" GetMethodName="GetDataByIdVendedor" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdVendedor" UserSourceName="FillByIdVendedor">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDVENDEDOR, IDTIPOVENDEDOR, IDZONA, ACUMULACOMISION
FROM         TER_VENDEDOR
WHERE     (IDVENDEDOR = :PIDVENDEDOR)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDVENDEDOR" ColumnName="IDVENDEDOR" DataSourceName="SAMUEL.TER_VENDEDOR" DataTypeServer="VARCHAR2(15)" DbType="String" Direction="Input" ParameterName=":PIDVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="15" SourceColumn="IDVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TER_TIPOCLIENTESTableAdapter" GeneratorDataComponentClassName="TER_TIPOCLIENTESTableAdapter" Name="TER_TIPOCLIENTES" UserDataComponentName="TER_TIPOCLIENTESTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_TIPOCLIENTES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."TER_TIPOCLIENTES" WHERE (("IDTIPO" = :Original_IDTIPO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."TER_TIPOCLIENTES" ("IDTIPO", "DESCRIPCION") VALUES (:IDTIPO, :DESCRIPCION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTIPO, DESCRIPCION FROM SAMUEL.TER_TIPOCLIENTES</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."TER_TIPOCLIENTES" SET "IDTIPO" = :IDTIPO, "DESCRIPCION" = :DESCRIPCION WHERE (("IDTIPO" = :Original_IDTIPO) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTIPO" DataSetColumn="IDTIPO" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_TIPOCLIENTES" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdTipoCliente" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByIdTipoCliente" GeneratorSourceName="FillByIdTipoCliente" GetMethodModifier="Public" GetMethodName="GetDataByIdTipoCliente" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByIdTipoCliente" UserSourceName="FillByIdTipoCliente">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDTIPO, DESCRIPCION
FROM         TER_TIPOCLIENTES
WHERE     (IDTIPO = :PIDTIPO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDTIPO" ColumnName="IDTIPO" DataSourceName="SAMUEL.TER_TIPOCLIENTES" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDTIPO" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TER_TIPOVENDEDORTableAdapter" GeneratorDataComponentClassName="TER_TIPOVENDEDORTableAdapter" Name="TER_TIPOVENDEDOR" UserDataComponentName="TER_TIPOVENDEDORTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_TIPOVENDEDOR" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM "SAMUEL"."TER_TIPOVENDEDOR" WHERE (("IDTIPOVENDEDOR" = :Original_IDTIPOVENDEDOR) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_PORCENTAJECOMISION = 1 AND "PORCENTAJECOMISION" IS NULL) OR ("PORCENTAJECOMISION" = :Original_PORCENTAJECOMISION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORCENTAJECOMISION" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORCENTAJECOMISION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PORCENTAJECOMISION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJECOMISION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO "SAMUEL"."TER_TIPOVENDEDOR" ("IDTIPOVENDEDOR", "DESCRIPCION", "ESTADO", "PORCENTAJECOMISION") VALUES (:IDTIPOVENDEDOR, :DESCRIPCION, :ESTADO, :PORCENTAJECOMISION)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PORCENTAJECOMISION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJECOMISION" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTIPOVENDEDOR, DESCRIPCION, ESTADO, PORCENTAJECOMISION FROM SAMUEL.TER_TIPOVENDEDOR</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE "SAMUEL"."TER_TIPOVENDEDOR" SET "IDTIPOVENDEDOR" = :IDTIPOVENDEDOR, "DESCRIPCION" = :DESCRIPCION, "ESTADO" = :ESTADO, "PORCENTAJECOMISION" = :PORCENTAJECOMISION WHERE (("IDTIPOVENDEDOR" = :Original_IDTIPOVENDEDOR) AND ((:IsNull_DESCRIPCION = 1 AND "DESCRIPCION" IS NULL) OR ("DESCRIPCION" = :Original_DESCRIPCION)) AND ((:IsNull_ESTADO = 1 AND "ESTADO" IS NULL) OR ("ESTADO" = :Original_ESTADO)) AND ((:IsNull_PORCENTAJECOMISION = 1 AND "PORCENTAJECOMISION" IS NULL) OR ("PORCENTAJECOMISION" = :Original_PORCENTAJECOMISION)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IDTIPOVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="PORCENTAJECOMISION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJECOMISION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_IDTIPOVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DESCRIPCION" Precision="0" ProviderType="Int32" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DESCRIPCION" Precision="0" ProviderType="Varchar2" Scale="0" Size="30" SourceColumn="DESCRIPCION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESTADO" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_ESTADO" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="ESTADO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PORCENTAJECOMISION" Precision="0" ProviderType="Int32" Scale="0" Size="22" SourceColumn="PORCENTAJECOMISION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_PORCENTAJECOMISION" Precision="0" ProviderType="Decimal" Scale="0" Size="22" SourceColumn="PORCENTAJECOMISION" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTIPOVENDEDOR" DataSetColumn="IDTIPOVENDEDOR" />
              <Mapping SourceColumn="DESCRIPCION" DataSetColumn="DESCRIPCION" />
              <Mapping SourceColumn="ESTADO" DataSetColumn="ESTADO" />
              <Mapping SourceColumn="PORCENTAJECOMISION" DataSetColumn="PORCENTAJECOMISION" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_TIPOVENDEDOR" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByidTipoVendedor" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByidTipoVendedor" GeneratorSourceName="FillByidTipoVendedor" GetMethodModifier="Public" GetMethodName="GetDataByidTipoVendedor" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByidTipoVendedor" UserSourceName="FillByidTipoVendedor">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     IDTIPOVENDEDOR, DESCRIPCION, ESTADO, PORCENTAJECOMISION
FROM         TER_TIPOVENDEDOR
WHERE     (IDTIPOVENDEDOR = :PIDTIPOVENDEDOR)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDTIPOVENDEDOR" ColumnName="IDTIPOVENDEDOR" DataSourceName="SAMUEL.TER_TIPOVENDEDOR" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDTIPOVENDEDOR" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (MySettings)" DbObjectName="SAMUEL.TER_TIPOVENDEDOR" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetDescripcionTipoVend" Modifier="Public" Name="GetDescripcionTipoVend" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetDescripcionTipoVend">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        DESCRIPCION
FROM            TER_TIPOVENDEDOR
WHERE        (IDTIPOVENDEDOR = :PIDTIPOVEND)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PIDTIPOVEND" ColumnName="IDTIPOVENDEDOR" DataSourceName="SAMUEL.TER_TIPOVENDEDOR" DataTypeServer="VARCHAR2(5)" DbType="String" Direction="Input" ParameterName=":PIDTIPOVEND" Precision="0" ProviderType="Varchar2" Scale="0" Size="5" SourceColumn="IDTIPOVENDEDOR" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsTercero" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsTercero" msprop:Generator_DataSetName="dsTercero" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="TER_TERCERO" msprop:Generator_UserTableName="TER_TERCERO" msprop:Generator_RowDeletedName="TER_TERCERORowDeleted" msprop:Generator_RowChangedName="TER_TERCERORowChanged" msprop:Generator_RowClassName="TER_TERCERORow" msprop:Generator_RowChangingName="TER_TERCERORowChanging" msprop:Generator_RowEvArgName="TER_TERCERORowChangeEvent" msprop:Generator_RowEvHandlerName="TER_TERCERORowChangeEventHandler" msprop:Generator_TableClassName="TER_TERCERODataTable" msprop:Generator_TableVarName="tableTER_TERCERO" msprop:Generator_RowDeletingName="TER_TERCERORowDeleting" msprop:Generator_TablePropName="TER_TERCERO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTERCERO" msprop:Generator_UserColumnName="IDTERCERO" msprop:Generator_ColumnVarNameInTable="columnIDTERCERO" msprop:Generator_ColumnPropNameInRow="IDTERCERO" msprop:Generator_ColumnPropNameInTable="IDTERCEROColumn" default="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NOMBRES" msprop:Generator_UserColumnName="NOMBRES" msprop:Generator_ColumnVarNameInTable="columnNOMBRES" msprop:Generator_ColumnPropNameInRow="NOMBRES" msprop:Generator_ColumnPropNameInTable="NOMBRESColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="APELLIDOS" msprop:Generator_UserColumnName="APELLIDOS" msprop:Generator_ColumnVarNameInTable="columnAPELLIDOS" msprop:Generator_ColumnPropNameInRow="APELLIDOS" msprop:Generator_ColumnPropNameInTable="APELLIDOSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DIRECCION" msprop:Generator_UserColumnName="DIRECCION" msprop:Generator_ColumnVarNameInTable="columnDIRECCION" msprop:Generator_ColumnPropNameInRow="DIRECCION" msprop:Generator_ColumnPropNameInTable="DIRECCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOCIDENT" msprop:Generator_UserColumnName="DOCIDENT" msprop:Generator_ColumnVarNameInTable="columnDOCIDENT" msprop:Generator_ColumnPropNameInRow="DOCIDENT" msprop:Generator_ColumnPropNameInTable="DOCIDENTColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ESTADO" msprop:Generator_UserColumnName="ESTADO" msprop:Generator_ColumnVarNameInTable="columnESTADO" msprop:Generator_ColumnPropNameInRow="ESTADO" msprop:Generator_ColumnPropNameInTable="ESTADOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDMUNICIPIO" msprop:Generator_UserColumnName="IDMUNICIPIO" msprop:Generator_ColumnVarNameInTable="columnIDMUNICIPIO" msprop:Generator_ColumnPropNameInRow="IDMUNICIPIO" msprop:Generator_ColumnPropNameInTable="IDMUNICIPIOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RAZONSOCIAL" msprop:Generator_UserColumnName="RAZONSOCIAL" msprop:Generator_ColumnVarNameInTable="columnRAZONSOCIAL" msprop:Generator_ColumnPropNameInRow="RAZONSOCIAL" msprop:Generator_ColumnPropNameInTable="RAZONSOCIALColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TELEFONO" msprop:Generator_UserColumnName="TELEFONO" msprop:Generator_ColumnVarNameInTable="columnTELEFONO" msprop:Generator_ColumnPropNameInRow="TELEFONO" msprop:Generator_ColumnPropNameInTable="TELEFONOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TIPODOCIDEN" msprop:Generator_UserColumnName="TIPODOCIDEN" msprop:Generator_ColumnVarNameInTable="columnTIPODOCIDEN" msprop:Generator_ColumnPropNameInRow="TIPODOCIDEN" msprop:Generator_ColumnPropNameInTable="TIPODOCIDENColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="REGIMEN" msprop:Generator_UserColumnName="REGIMEN" msprop:Generator_ColumnVarNameInTable="columnREGIMEN" msprop:Generator_ColumnPropNameInRow="REGIMEN" msprop:Generator_ColumnPropNameInTable="REGIMENColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="GRANCONTRIBUYENTE" msprop:Generator_UserColumnName="GRANCONTRIBUYENTE" msprop:Generator_ColumnVarNameInTable="columnGRANCONTRIBUYENTE" msprop:Generator_ColumnPropNameInRow="GRANCONTRIBUYENTE" msprop:Generator_ColumnPropNameInTable="GRANCONTRIBUYENTEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AUTORETENEDOR" msprop:Generator_UserColumnName="AUTORETENEDOR" msprop:Generator_ColumnVarNameInTable="columnAUTORETENEDOR" msprop:Generator_ColumnPropNameInRow="AUTORETENEDOR" msprop:Generator_ColumnPropNameInTable="AUTORETENEDORColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DV" msprop:Generator_UserColumnName="DV" msprop:Generator_ColumnPropNameInRow="DV" msprop:Generator_ColumnVarNameInTable="columnDV" msprop:Generator_ColumnPropNameInTable="DVColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TER_CLIENTES" msprop:Generator_UserTableName="TER_CLIENTES" msprop:Generator_RowDeletedName="TER_CLIENTESRowDeleted" msprop:Generator_RowChangedName="TER_CLIENTESRowChanged" msprop:Generator_RowClassName="TER_CLIENTESRow" msprop:Generator_RowChangingName="TER_CLIENTESRowChanging" msprop:Generator_RowEvArgName="TER_CLIENTESRowChangeEvent" msprop:Generator_RowEvHandlerName="TER_CLIENTESRowChangeEventHandler" msprop:Generator_TableClassName="TER_CLIENTESDataTable" msprop:Generator_TableVarName="tableTER_CLIENTES" msprop:Generator_RowDeletingName="TER_CLIENTESRowDeleting" msprop:Generator_TablePropName="TER_CLIENTES">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCLIENTE" msprop:Generator_UserColumnName="IDCLIENTE" msprop:Generator_ColumnVarNameInTable="columnIDCLIENTE" msprop:Generator_ColumnPropNameInRow="IDCLIENTE" msprop:Generator_ColumnPropNameInTable="IDCLIENTEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDCANAL" msprop:Generator_UserColumnName="IDCANAL" msprop:Generator_ColumnVarNameInTable="columnIDCANAL" msprop:Generator_ColumnPropNameInRow="IDCANAL" msprop:Generator_ColumnPropNameInTable="IDCANALColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDVENDEDOR" msprop:Generator_UserColumnName="IDVENDEDOR" msprop:Generator_ColumnVarNameInTable="columnIDVENDEDOR" msprop:Generator_ColumnPropNameInRow="IDVENDEDOR" msprop:Generator_ColumnPropNameInTable="IDVENDEDORColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDFORMAPAGO" msprop:Generator_UserColumnName="IDFORMAPAGO" msprop:Generator_ColumnVarNameInTable="columnIDFORMAPAGO" msprop:Generator_ColumnPropNameInRow="IDFORMAPAGO" msprop:Generator_ColumnPropNameInTable="IDFORMAPAGOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUPO" msprop:Generator_UserColumnName="CUPO" msprop:Generator_ColumnVarNameInTable="columnCUPO" msprop:Generator_ColumnPropNameInRow="CUPO" msprop:Generator_ColumnPropNameInTable="CUPOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ESTADO" msprop:Generator_UserColumnName="ESTADO" msprop:Generator_ColumnVarNameInTable="columnESTADO" msprop:Generator_ColumnPropNameInRow="ESTADO" msprop:Generator_ColumnPropNameInTable="ESTADOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDLISTAGLOBAL" msprop:Generator_UserColumnName="IDLISTAGLOBAL" msprop:Generator_ColumnVarNameInTable="columnIDLISTAGLOBAL" msprop:Generator_ColumnPropNameInRow="IDLISTAGLOBAL" msprop:Generator_ColumnPropNameInTable="IDLISTAGLOBALColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTIPO" msprop:Generator_UserColumnName="IDTIPO" msprop:Generator_ColumnVarNameInTable="columnIDTIPO" msprop:Generator_ColumnPropNameInRow="IDTIPO" msprop:Generator_ColumnPropNameInTable="IDTIPOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NOMBREESTABLECIMIENTO" msprop:Generator_UserColumnName="NOMBREESTABLECIMIENTO" msprop:Generator_ColumnVarNameInTable="columnNOMBREESTABLECIMIENTO" msprop:Generator_ColumnPropNameInRow="NOMBREESTABLECIMIENTO" msprop:Generator_ColumnPropNameInTable="NOMBREESTABLECIMIENTOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SUCURSAL" msprop:Generator_UserColumnName="SUCURSAL" msprop:Generator_ColumnVarNameInTable="columnSUCURSAL" msprop:Generator_ColumnPropNameInRow="SUCURSAL" msprop:Generator_ColumnPropNameInTable="SUCURSALColumn" type="xs:decimal" />
              <xs:element name="IDBODEGA" msprop:Generator_UserColumnName="IDBODEGA" msprop:Generator_ColumnVarNameInTable="columnIDBODEGA" msprop:Generator_ColumnPropNameInRow="IDBODEGA" msprop:Generator_ColumnPropNameInTable="IDBODEGAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TER_PROVEEDORES" msprop:Generator_UserTableName="TER_PROVEEDORES" msprop:Generator_RowDeletedName="TER_PROVEEDORESRowDeleted" msprop:Generator_RowChangedName="TER_PROVEEDORESRowChanged" msprop:Generator_RowClassName="TER_PROVEEDORESRow" msprop:Generator_RowChangingName="TER_PROVEEDORESRowChanging" msprop:Generator_RowEvArgName="TER_PROVEEDORESRowChangeEvent" msprop:Generator_RowEvHandlerName="TER_PROVEEDORESRowChangeEventHandler" msprop:Generator_TableClassName="TER_PROVEEDORESDataTable" msprop:Generator_TableVarName="tableTER_PROVEEDORES" msprop:Generator_RowDeletingName="TER_PROVEEDORESRowDeleting" msprop:Generator_TablePropName="TER_PROVEEDORES">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPROVEEDOR" msprop:Generator_UserColumnName="IDPROVEEDOR" msprop:Generator_ColumnVarNameInTable="columnIDPROVEEDOR" msprop:Generator_ColumnPropNameInRow="IDPROVEEDOR" msprop:Generator_ColumnPropNameInTable="IDPROVEEDORColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDFORMAPAGO" msprop:Generator_UserColumnName="IDFORMAPAGO" msprop:Generator_ColumnVarNameInTable="columnIDFORMAPAGO" msprop:Generator_ColumnPropNameInRow="IDFORMAPAGO" msprop:Generator_ColumnPropNameInTable="IDFORMAPAGOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CUPO" msprop:Generator_UserColumnName="CUPO" msprop:Generator_ColumnVarNameInTable="columnCUPO" msprop:Generator_ColumnPropNameInRow="CUPO" msprop:Generator_ColumnPropNameInTable="CUPOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ESTADO" msprop:Generator_UserColumnName="ESTADO" msprop:Generator_ColumnVarNameInTable="columnESTADO" msprop:Generator_ColumnPropNameInRow="ESTADO" msprop:Generator_ColumnPropNameInTable="ESTADOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EMAIL" msprop:Generator_UserColumnName="EMAIL" msprop:Generator_ColumnVarNameInTable="columnEMAIL" msprop:Generator_ColumnPropNameInRow="EMAIL" msprop:Generator_ColumnPropNameInTable="EMAILColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PAGWEB" msprop:Generator_UserColumnName="PAGWEB" msprop:Generator_ColumnVarNameInTable="columnPAGWEB" msprop:Generator_ColumnPropNameInRow="PAGWEB" msprop:Generator_ColumnPropNameInTable="PAGWEBColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TER_VENDEDOR" msprop:Generator_UserTableName="TER_VENDEDOR" msprop:Generator_RowDeletedName="TER_VENDEDORRowDeleted" msprop:Generator_RowChangedName="TER_VENDEDORRowChanged" msprop:Generator_RowClassName="TER_VENDEDORRow" msprop:Generator_RowChangingName="TER_VENDEDORRowChanging" msprop:Generator_RowEvArgName="TER_VENDEDORRowChangeEvent" msprop:Generator_RowEvHandlerName="TER_VENDEDORRowChangeEventHandler" msprop:Generator_TableClassName="TER_VENDEDORDataTable" msprop:Generator_TableVarName="tableTER_VENDEDOR" msprop:Generator_RowDeletingName="TER_VENDEDORRowDeleting" msprop:Generator_TablePropName="TER_VENDEDOR">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDVENDEDOR" msprop:Generator_UserColumnName="IDVENDEDOR" msprop:Generator_ColumnVarNameInTable="columnIDVENDEDOR" msprop:Generator_ColumnPropNameInRow="IDVENDEDOR" msprop:Generator_ColumnPropNameInTable="IDVENDEDORColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTIPOVENDEDOR" msprop:Generator_UserColumnName="IDTIPOVENDEDOR" msprop:Generator_ColumnVarNameInTable="columnIDTIPOVENDEDOR" msprop:Generator_ColumnPropNameInRow="IDTIPOVENDEDOR" msprop:Generator_ColumnPropNameInTable="IDTIPOVENDEDORColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDZONA" msprop:Generator_UserColumnName="IDZONA" msprop:Generator_ColumnVarNameInTable="columnIDZONA" msprop:Generator_ColumnPropNameInRow="IDZONA" msprop:Generator_ColumnPropNameInTable="IDZONAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACUMULACOMISION" msprop:Generator_UserColumnName="ACUMULACOMISION" msprop:Generator_ColumnVarNameInTable="columnACUMULACOMISION" msprop:Generator_ColumnPropNameInRow="ACUMULACOMISION" msprop:Generator_ColumnPropNameInTable="ACUMULACOMISIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TER_TIPOCLIENTES" msprop:Generator_UserTableName="TER_TIPOCLIENTES" msprop:Generator_RowDeletedName="TER_TIPOCLIENTESRowDeleted" msprop:Generator_RowChangedName="TER_TIPOCLIENTESRowChanged" msprop:Generator_RowClassName="TER_TIPOCLIENTESRow" msprop:Generator_RowChangingName="TER_TIPOCLIENTESRowChanging" msprop:Generator_RowEvArgName="TER_TIPOCLIENTESRowChangeEvent" msprop:Generator_RowEvHandlerName="TER_TIPOCLIENTESRowChangeEventHandler" msprop:Generator_TableClassName="TER_TIPOCLIENTESDataTable" msprop:Generator_TableVarName="tableTER_TIPOCLIENTES" msprop:Generator_RowDeletingName="TER_TIPOCLIENTESRowDeleting" msprop:Generator_TablePropName="TER_TIPOCLIENTES">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTIPO" msprop:Generator_UserColumnName="IDTIPO" msprop:Generator_ColumnVarNameInTable="columnIDTIPO" msprop:Generator_ColumnPropNameInRow="IDTIPO" msprop:Generator_ColumnPropNameInTable="IDTIPOColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TER_TIPOVENDEDOR" msprop:Generator_UserTableName="TER_TIPOVENDEDOR" msprop:Generator_RowDeletedName="TER_TIPOVENDEDORRowDeleted" msprop:Generator_RowChangedName="TER_TIPOVENDEDORRowChanged" msprop:Generator_RowClassName="TER_TIPOVENDEDORRow" msprop:Generator_RowChangingName="TER_TIPOVENDEDORRowChanging" msprop:Generator_RowEvArgName="TER_TIPOVENDEDORRowChangeEvent" msprop:Generator_RowEvHandlerName="TER_TIPOVENDEDORRowChangeEventHandler" msprop:Generator_TableClassName="TER_TIPOVENDEDORDataTable" msprop:Generator_TableVarName="tableTER_TIPOVENDEDOR" msprop:Generator_RowDeletingName="TER_TIPOVENDEDORRowDeleting" msprop:Generator_TablePropName="TER_TIPOVENDEDOR">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTIPOVENDEDOR" msprop:Generator_UserColumnName="IDTIPOVENDEDOR" msprop:Generator_ColumnVarNameInTable="columnIDTIPOVENDEDOR" msprop:Generator_ColumnPropNameInRow="IDTIPOVENDEDOR" msprop:Generator_ColumnPropNameInTable="IDTIPOVENDEDORColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DESCRIPCION" msprop:Generator_UserColumnName="DESCRIPCION" msprop:Generator_ColumnVarNameInTable="columnDESCRIPCION" msprop:Generator_ColumnPropNameInRow="DESCRIPCION" msprop:Generator_ColumnPropNameInTable="DESCRIPCIONColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ESTADO" msprop:Generator_UserColumnName="ESTADO" msprop:Generator_ColumnVarNameInTable="columnESTADO" msprop:Generator_ColumnPropNameInRow="ESTADO" msprop:Generator_ColumnPropNameInTable="ESTADOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PORCENTAJECOMISION" msprop:Generator_UserColumnName="PORCENTAJECOMISION" msprop:Generator_ColumnVarNameInTable="columnPORCENTAJECOMISION" msprop:Generator_ColumnPropNameInRow="PORCENTAJECOMISION" msprop:Generator_ColumnPropNameInTable="PORCENTAJECOMISIONColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TER_TERCERO" />
      <xs:field xpath="mstns:IDTERCERO" />
    </xs:unique>
    <xs:unique name="TER_CLIENTES_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TER_CLIENTES" />
      <xs:field xpath="mstns:IDCLIENTE" />
      <xs:field xpath="mstns:SUCURSAL" />
    </xs:unique>
    <xs:unique name="TER_PROVEEDORES_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TER_PROVEEDORES" />
      <xs:field xpath="mstns:IDPROVEEDOR" />
    </xs:unique>
    <xs:unique name="TER_VENDEDOR_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TER_VENDEDOR" />
      <xs:field xpath="mstns:IDVENDEDOR" />
    </xs:unique>
    <xs:unique name="TER_TIPOCLIENTES_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TER_TIPOCLIENTES" />
      <xs:field xpath="mstns:IDTIPO" />
    </xs:unique>
    <xs:unique name="TER_TIPOVENDEDOR_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TER_TIPOVENDEDOR" />
      <xs:field xpath="mstns:IDTIPOVENDEDOR" />
    </xs:unique>
    <xs:keyref name="FK_TER_TERCERO_TER_VENDEDOR" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_TER_TERCERO_TER_VENDEDOR" msprop:rel_Generator_RelationVarName="relationFK_TER_TERCERO_TER_VENDEDOR" msprop:rel_Generator_UserChildTable="TER_VENDEDOR" msprop:rel_Generator_UserParentTable="TER_TERCERO" msprop:rel_Generator_ParentPropName="TER_TERCERORow" msprop:rel_Generator_ChildPropName="GetTER_VENDEDORRows">
      <xs:selector xpath=".//mstns:TER_VENDEDOR" />
      <xs:field xpath="mstns:IDVENDEDOR" />
    </xs:keyref>
    <xs:keyref name="FK_TER_TERCERO_TER_PROVEEDORES" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_TER_TERCERO_TER_PROVEEDORES" msprop:rel_Generator_RelationVarName="relationFK_TER_TERCERO_TER_PROVEEDORES" msprop:rel_Generator_UserChildTable="TER_PROVEEDORES" msprop:rel_Generator_UserParentTable="TER_TERCERO" msprop:rel_Generator_ParentPropName="TER_TERCERORow" msprop:rel_Generator_ChildPropName="GetTER_PROVEEDORESRows">
      <xs:selector xpath=".//mstns:TER_PROVEEDORES" />
      <xs:field xpath="mstns:IDPROVEEDOR" />
    </xs:keyref>
    <xs:keyref name="FK_TER_TERCERO_TER_CLIENTES" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_TER_TERCERO_TER_CLIENTES" msprop:rel_Generator_RelationVarName="relationFK_TER_TERCERO_TER_CLIENTES" msprop:rel_Generator_UserChildTable="TER_CLIENTES" msprop:rel_Generator_UserParentTable="TER_TERCERO" msprop:rel_Generator_ParentPropName="TER_TERCERORow" msprop:rel_Generator_ChildPropName="GetTER_CLIENTESRows">
      <xs:selector xpath=".//mstns:TER_CLIENTES" />
      <xs:field xpath="mstns:IDCLIENTE" />
    </xs:keyref>
  </xs:element>
</xs:schema>